{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Mac PC share data"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Mac PC share data","index":0,"n_rows":29,"n_cols":8,"rows_kept":29,"cut":false,"hidden":false,"merged":[[13,1,13,4]]}
[null,"4Q10 shipments","Market share 4Q10","4Q11 shipments","Market share 4Q11","Change over prior year (2011 to 2010) - units","Change over prior year (2011 to 2010) - growth","Change over prior year (2011 to 2010) - change in share"]
["HP",5598619,null,4137833]
["Dell",4210000,null,4020549]
["Apple",1718400,null,2047800]
["Toshiba",1968091,null,1925100]
["Acer",1982477,null,1756838]
["Others",3583418,null,4014644]
["Total"]
[]
[]
[]
[]
[]
[null,"Instructions"]
[]
[null,"1.","Using the Excel built in function, calculate in cell B8 the total number of shipments for the 4th quarter of 2010  (4Q10)"]
[null,"2.","Using the Excel built in function, calculate in cell D8 the total number of shipments for the 4th quarter of 2011 (4Q11)"]
[null,"3.","Format columns B and D so that the thousands are separated by a comma but without any decimal places"]
[null,"4.","In cell C2, calculate HP's market share (divide the number of units it shipped by the total industry shipments). Use a absolute row, relative column address for the denominator."]
[null,"5.","Copy your calculation to all the cells underneath down to C8. Cell C8 should show '1'"]
[null,"6.","Format the numbers in column C as a percentage with no decimals"]
[null,"7.","Select cells C2:C8 and copy this range to E2"]
[null,"8.","In cell F2, calculate the difference between HP's 4Q11 shipments and its 4Q10 shipments"]
[null,"9.","Copy your calculation to all the cells underneath down to F8. "]
[null,"10.","Format in bold those cells in which show an increase in units shipped"]
[null,"11.","Calculate in cell G2 the percentage increase in HP's units shipped in 4Q11 relative to its 4Q10 shipments (format as a percentage with no decimals)"]
[null,"12.","Copy your calculations from G2 into the range G3:G8"]
[null,"13.","In cells H2 to H7 Subtract the market shares in 4Q10 from those of 4Q11 (don't bother with H8 since the result will always be 0) "]
[null,"14.","Format the range H2:H7 as a percentage with two places of decimals."]